package com.yjdb.sanyuantang.generator.source;

/**
 * @ClassName SqlCommond
 * @Description TDD
 * @Author 混沌酱
 * @Date 2023-08-08 13:40
 * @Version 1.0
 **/
public class SqlCommand {

    /**
     * 获取所有表
     */
    public static final String TABLES = "show tables";

    /**
     * 获取表的主键
     */
    public static final String PRIMARYKEY = "SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS\n" +
            "WHERE TABLE_SCHEMA='DATANAME' AND TABLE_NAME='TABLENAME' AND COLUMN_KEY='PRI';";
}
